For INTERVAL DAY TO SECOND data type:
Day Precision
Set the number of digits in the leading field. Accepted values are 0 to 9. The default is 2.Fractional Seconds Precision
Set the number of digits in the fractional part of the SECOND datetime field. Accepted values are 1 to 9.
For INTERVAL YEAR TO MONTH data type:
Year Precision
Set the number of digits in the year. The default is 2.
For TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE data types:
Fractional Seconds Precision
Set the number of digits in the fractional part of the SECOND datetime field. Accepted values are 1 to 9.
For CHAR, VARCHAR2 data types:
Unit
Set the unit either in BYTE or CHAR.
For USER-DEFINED data type:
Schema
Set the schema for the field.User-defined Type
Set the type for the field.